<?php
/*
Copyright (C) 2009 de Flotte Maxence

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
?>
<?php
class ZzSQL {
	
	static function exec($query, $label = null) {
		$return = ZzSQL::prepare($query, $label);
		if(!$resultat)
			return 0;
		return $return;
	}
	
	static function lastInsertId() {
		return $GLOBALS['sql']->lastInsertId();
	}
	static function query($query, $label = null) {
		$result  = ZzSQL::prepare($query, $label);
		$return = array();
		if(!$result)
			return $return;
		while($row = $result ->fetch(PDO::FETCH_ASSOC))
			$return[] = $row;
		return $return;
	}	
	
	static function queryFirst($query, $label = null) {
		$result  = ZzSQL::prepare($query, $label);
		if(!$result)
			return null;
		if($row = $result ->fetch(PDO::FETCH_ASSOC))
			return $row;
		return null;
	}
	
	static function beginTransaction() {
		$GLOBALS['sql']->beginTransaction();
	}
	
	static function rollBack() {
		$GLOBALS['sql']->rollBack();
	}
	
	static function commit() {
		$GLOBALS['sql']->commit();
	}
	
	static function prepare($query, $label = null) {
		$GLOBALS['nbSQLQuery']++;
		//echo $GLOBALS['nbSQLQuery'],':',$query,'<br/>';
		$sql = $GLOBALS['sql'];
		$result = $sql->prepare($query);
		if($result->execute($label));
			return $result;
		return false;
	}
}
?>